package com.jk.dao;

import com.jk.pojo.PayUser;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.Scanner;

/**
 * 根据用户id查询用户积分dao层接口
 * cjq
 * Created by Administrator on 2017/12/20 0020.
 */
public interface PayUserIntegralDao {
    //根据用户id查询用户会员积分
    @Select("select * from pay_user where userId = #{userid}")
    PayUser queryPayUserIntegralCount(String userid);

    //定时器定时清空用户的会员积分
    @Delete("update pay_user set userIntegral=0")
    void editPayUserIntegralCount();

    //使用定时器为会员用户送上生日祝福
    @Select("select * from pay_user where userId = #{userid}")
    PayUser queryPayUserIdentityCard(String userid);
}
